International vs American date format in submitted web forms

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject: International vs American date format in submitted web forms

Feedback Type: Problem

Product Area: Domino Designer on Eclipse (DDE)

Technical Area: Application Development

Platform: Not Applicable

Release: 8.5.2

Reproducible: Intermittent

Problem summary: month / day seems to get reversed on some user's machine in web submissions.

I have a date picker on a web form, consists of drop down fields. You choose month in first field, then day in second field, then year, hour, and minutes to set time. Then choose AM or PM.

fields:
MM / DD / YYYY / Hour / Min / AMPM

Then in a hidden computed field, I put them all together in a computed proper DateTime notes field, whose property is set to be DateTime.

TempTime := YY +"/" + MM + "/" + DD + " " + Hour + ":" + Min + ":00 " + AMPM;
@TextToTime(TempTime);

Problem: It seems that if people are running their machines on international date format (10th August 2011 instead of American format August 10th, 2011) then the DateTime field computes according to *their* settings, not the settings on the server, and not according to the formula I have shown above.

Anyway to avoid this?

Feedback number WEBB8KEFWZ created by ~Zach Quetponesononi on 08/04/2011

Status: Open
Comments: